Invalid Characters

Поиск
Список
Период
Сортировка
От Raman
Тема Invalid Characters
Дата
Msg-id 00ec01c40a79$7ec4be00$d4c7a8c0@raman
обсуждение исходный текст
Ответы Re: Invalid Characters  (Paul Thomas <paul@tmsl.demon.co.uk>)
Список pgsql-sql
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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Yasir Malik
Дата:
Сообщение: Object-relational features
Следующее
От: Paul Thomas
Дата:
Сообщение: Re: Invalid Characters