Hi all,

Can anyone explain why I am getting this error:

Invalid character data was found. This is most likely caused by stored data
containing characters that are invalid for the character set the database
was created in. The most common example of this is storing 8bit data in a
SQL_ASCII database.

this error occurs only on some records, even though they are all of type
"text" and even when I use SET CLIENT_ENCODING TO 'UNICODE'; in my queries.

The db is postgresql 7.3 on linux, coldfusion version is MX6.1 on linux.

Cheers,
Bryan.

Bryan Nolen
Lead Developer, Arc.Net.Au
Ph: 03 9499 2929
Fax: 03 9499 4545
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] 
http://Arc.Net.AU
http://cdonline.com.au


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004

Reply via email to