Multilanguge+PHP+MS SQL

[web_server]

Hi there,
I'm using MSSQL server 2000 for database. I changed MSSQL to fit the languge I need . I tried to insert data in the MSSQL manually (by inserting it in the table by myself ) and then retriveing it using PHP but all I get was rabbish.
I also tried to insert the data using PHP but it is inserted as a rabbish in the DB .
any ideas?
thank you.

[coopster]

Since you able to insert and retrieve something then I would assume you have your PHP and MSSQL code functioning together correctly. Now all you need to do is set the language correctly prior to INSERT.

[chadha]

Hello web_server,

If you are planning on building something multilingual with PHP, then why not create language files and make your page content dynamic so that all the data to display comes from the language files...?

[omoutop]

Double check the Collation of your database/tables and the encoding of your pages. If you can type something correctly, then you can save it correctly!

[web_server]

Hi there ,
thank you all for your posts.
I tried every possible collation but nothing works.
could it be a problem in PHP-MSSQL extension?
I've heared somthing called ODBC connectivity. could it be helpful?

thank you.