Inserting ä into a MSSQL database by cold fusion

[Lancelotian]

I have a parameter in my mssql databse with a type of nvarchar. When I try to insert a character chr(228)

ä

I get the ? in my database instead of

ä

Any one who can help.

Thanks in advance for your response.

[BKBK]

Try this:

INSERT INTO TBL(unicodeCol) VALUES (N'#chr(228)#')

Reference: http://support.microsoft.com/kb/239530

[Lancelotian]

Thanks a lot for your response, I did enable de non-latin in my DSN through cf admin and it works.

Thanks again