Page 1 of 1
PHP -> hebrew -> ASP
Posted: Wed Sep 10, 2008 3:06 pm
by snooper
Hey folks.
I have a Vbulletin installation running, in Hebrew. the pages are all Win-1255 encoded.
I also have an ASP app, that is trying to access the Vbulletin database (mysql of course), but the data i am getting come out as question marks - '?????'
any ideas?
thanks!
Re: PHP -> hebrew -> ASP
Posted: Wed Sep 10, 2008 3:45 pm
by dml
I suppose the first thing to check is whether the data is correctly stored in Mysql. If it is, then that isolates the problem to the ASP application. If it isn't, then the PHP application has presumably put the data in wrong, so you can either fix it at the PHP end, or hack the ASP application to correct it before processing.
Can you run charset() and hex() on a short fragment of the text that's giving you a problem, for example:
Code: Select all
SELECT charset(mycol), LEFT(col, 10), hex(LEFT(col,10)) FROM mytable LIMIT 1
Re: PHP -> hebrew -> ASP
Posted: Tue Sep 23, 2008 6:44 pm
by snooper
hi and sorry for the looooong delay in replying.
i tried your suggestion, using this -
Code: Select all
sql = "SELECT userid, charset(homepage), LEFT(homepage, 20), hex(LEFT(homepage,20)) FROM `user` u ORDER BY userid LIMIT 10;"
using this response,
Code: Select all
response.Write("<BR>" & rs(0) & "-" & rs(1) & "-" & rs(2) & "-" & rs(3) )
i got this:
1-utf8--
does this help at all?
thanks!