We are in the process of supporting UTF-8 storage in our database and have fields that are UTF-8 but the base character set of the DB is still ASCII-7 and will remain that way.
If I do an update to an NVARCHAR field like this.
UPDATE
TAF_OFFER_REWARD_MASTER
SET
TORMAS_SHORT_DESCRIPTION = unistr(<cfqueryparam cfsqltype="CF_SQL_NVARCHAR" value="'Fran\00E7ais">)
WHERE
TORMAS_TAF_OFFER_REWARD_ID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="55">
It gets stored correctly which I have verified by doing an Oracle dump of the field.
0,46,0,72,0,61,0,6e,0,e7,0,61,0,69,0,73
This charcter is a lower case c with a circumflex but when I display it I just get a lower case c. The conversion appears to be happening either in the database or the driver. Any suggestions?
Shawn McKee
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
