KNOWLEDGE BASE
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
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

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

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 ( http://www.4d.com/support/documentation.html )