Japanese Characters: kanji, etc.

[Gast]

I have a few fields with Japanese characters. The web pages display the data ok; they are encoded utf-8.

But when I try to do a database update, e.g.,
UPDATE table SET field = 'フェノキシエタノール'
WHERE ...

I end up with rubbish in the database field.

Also tried cfqueryparam with cfsqltype set to cblob (error), varchar (rubbish ) and longvarchar (rubbish ). There is no type nvarchar. Is there any way to get this data into the database via a CF query?

[Gast]

The database needs to support unicode in order for this to work.

[Newsgroup_User]

Tom Stuart 2 wrote:
> Also tried cfqueryparam with cfsqltype set to cblob (error), varchar (rubbish
> ) and longvarchar (rubbish ). There is no type nvarchar. Is there any way to
> get this data into the database via a CF query?

use cfqueryparam w/varchar cfsqltype. by your use of nvarchar i'll assume you're
using sql server, so did you set the "Enable Unicode for data sources configured
for non-Latin characters" option for that dsn? it's in the advanced menu. see

http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=F9553D86-20ED-7DEE-2A913AFD8651...

[Gast · Accepted solution]

This solves the problem. Thanks very much.

Is there any downside to enabling Unicode in the connection?

[Newsgroup_User]

Tom Stuart 2 wrote:
> Is there any downside to enabling Unicode in the connection?

not if you need to use unicode.