Re: Invalid Characters
От | Paul Thomas |
---|---|
Тема | Re: Invalid Characters |
Дата | |
Msg-id | 20040315114223.A412@bacon обсуждение исходный текст |
Ответ на | Invalid Characters ("Raman" <ramang@smartdatainc.com>) |
Список | pgsql-sql |
On 15/03/2004 10:37 Raman wrote: > Hi All, > > I have imported some data from csv files in my DB. Now that data has some > invalid characters stored in it. > so I get this exception: > > Exception in ChannelDAO 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. > > > Now, I tried using to_ascii() fn in my select query but it didn't work. > Cn you please suggest any solution so that invalid characters should not > come to my webpage while displaying. > > Regards > Raman Garg > Use UNICODE as the db encoding. You'll have to drop and re-create the db though. HTH -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
В списке pgsql-sql по дате отправления: