Search Postgresql Archives

problem with the select query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi people,
 
 this is my first mail to the group. i am having a problem with the select query.
There are a few values in few columns of a table with some special characters like ~E and ~A and what all, and when i query the database with the select query then the ~E is getting converted into a new line character and i dont know how to solve this problem
 
Here are a few more examples of the values i see in the tables
 
h+Ï^UÈά^G:iÌ¿¤àÝÇð::::\N
~A^[´B:øÕ£^T´ÂªM
Ý.¨\t\r~IRB:8(LmBö.~E
 
My question here is that can i use the select query to extract the data with all these special characters as it is, I mean the ~E here will make the extracted dump to get to the next line which i dont want it to do and the \r is a carriage return. I want these special characters to remain as it is.


Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux