Inserting ä into a MSSQL database by cold fusion

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.

This topic has been closed for replies.

Community Expert

Try this:

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

Participating Frequently

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

Thanks again

Sign up