PDA

View Full Version : Unicode symbols in the SQLScript are processed incorrectly



miryamgb
06-11-2004, 10:21 AM
Symbols from "Private Use Characters" Unicode Subrange in the SQLScript are saved incorrectly to the Database.

Trace in SQL Profiler shows incorrect symbol.

The same script works fine from SQL Query Analyzer


Please find attached project for verification.
Used Font - Arial
Symbol - U+E804 Private Use
(on Windows XP to look up character go to Start/All Programs/Accessories/System Tools/Character Map)

The Sreen shot of SQL Profiler is also included.

Thank you
Miryam

hidenori
06-16-2004, 03:00 PM
Miryam,

The problem is confirmed. I submitted the work order #1-Q17IG to address this issue in a future release.

Thank you for reporting this.
Hidenori Yamanishi
InstallShield Software Corp

miryamgb
07-21-2004, 07:54 AM
Hidenori,

Is there any chance this will make into the first patch?

Thank you
Miryam

hidenori
07-21-2004, 10:28 AM
Unfortunately, this fix for the work order #1-Q17IG will not be available in the first service pack. Likely in the second serivce pack or the next major release.

Regards,
Hidenori Yamanishi