CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI: DBI Encoding/Decoding: Edit Log



packetstormer
New User

Feb 2, 2012, 12:43 PM


Views: 13144
DBI Encoding/Decoding

Hello,
I am really struggling with this. I have inherited a MSSQL server and I need to retrive data from a certain table. The problem is some of the data returns like this:
"Im trying to find out......"
Note the problem with the "I'm". The database collation is set to SQL_Latin1_General_CP1_CI_AS. I have tried decoding the string as "Latin1", "ISO-8859-1" and "Windows-1252" and the most I can manage to do is change the "" to a "?".
I have also tried to bind the column type to SQL_WCHAR in the script but still it fails to display correctly.

Can anyone help?

EDIT: A regular expression to substitute "" for "'" has worked but I am not too sure this is the correct way to do it??


(This post was edited by packetstormer on Feb 2, 2012, 1:08 PM)


Edit Log:
Post edited by packetstormer (New User) on Feb 2, 2012, 1:08 PM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives