Log In    |    Knowledge Base    |    4D Home
Tech Tip: Reserved character codes in 4D v11 SQL
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: September 4, 2008

In 4D v11 SQL, certain character codes are reserved and must never be included in text. These character codes are:

Using any of these characters in text can lead to unexpected results. For example, inserting Char(0) in a text field will truncate text that precedes it.

Commented by Jesse Pina on August 14, 2009 at 3:33 PM
For full details regarding unicode related changes, see the 4D v11 SQL Upgrade manual ( )