Dreamweaver - mySQL + hebrew

Author

mySQL + hebrew

Dog

2004-04-21, 2:36 pm

hi,

i'm just starting to use mysql after using Access for a while. i'm
converting some Access dbs containing Hebrew text into mySQL.
This seems fine and the data seems intact when i view the content using
navicat front end.

i use asp to display the data and it all comes out as ???????? .

the same happens with access but can be solved by putting codepage="1255" at
the top of the page.
unfortunatly this doesn't seem to work with mySQL.

even hebrew i insert into the db using a web page form comes is seen as
?????

is this a database problem, page encoding problem or something else?

any suggestions would be appreciated.

Dog

-Rb

2004-04-21, 2:38 pm

"Dog" <dog@emotiveSPAM.co.il -= no spam is good spam :-)> wrote in message
news:c5hke7$hgo$1@forums.macromedia.com...
> hi,
>
> i'm just starting to use mysql after using Access for a while. i'm
> converting some Access dbs containing Hebrew text into mySQL.
> This seems fine and the data seems intact when i view the content using
> navicat front end.
>
> i use asp to display the data and it all comes out as ???????? .
>
> the same happens with access but can be solved by putting codepage="1255" at
> the top of the page.
> unfortunatly this doesn't seem to work with mySQL.
>
> even hebrew i insert into the db using a web page form comes is seen as
> ?????
>
> is this a database problem, page encoding problem or something else?
>
> any suggestions would be appreciated.
>
> Dog
>
>

Check out the mysql documentation on Character Sets.

< http://dev.mysql.com/doc/ >

HTH

-Rb