UNICODE with cfqueryparam tag

2009-12-04 Thread Paul Alkema
Hi, I've been having an issue. I am currently using CF8 and would like to insert UNICODE into a table while using the cfqueryparam tag. Upon some research[1] I found many articles that said if you enable the setting High ASCII characters and Unicode for data sources configured for non-Latin

Re: UNICODE with cfqueryparam tag

2009-12-04 Thread Paul Hastings
On 12/4/2009 9:17 PM, Paul Alkema wrote: administrator that it will allow this. However, upon doing so my MSSQL server crashed every time. I have researched this over and over and havn't seen any other people having this issue. never heard of this happening. what do you mean by crash? if you

Re: UNICODE with cfqueryparam tag

2009-12-04 Thread Jason Fisher
First check that the necessary columns are set to ntext or nvarchar, not text or varchar. If that's not the issue then put the N in front of each, as Paul mentioned. If that doesn't work, then what version of SQL Server are you on ... older versions may not support 8-bit entries ... never