Jump to content
Login with your Gmail HERE and start posting in seconds! ×
Don't just read! Be part of the Community! Join the conversation ×

Multiple language website

bkkmick

By bkkmick
in IT and Computers

 Share

Recommended Posts

bkkmick Gold Member

bkkmick

Posted
Posted

Hi

I'm working on a website for a friend. He wants the site to be available in multiple languages.

I set up an SQL table called languages with two fields the first field is the language code (EN, TH etc.) and the second contains the wording in that foreign language (English, ภาษาไทย). The second field is datatype nvarchar(max). When I look at the content of the table in SQL Server Management Studio everything looks fine (various languages are displayed correctly).

The problem is that, when I extract the language data from the table and try and display them in a page, the foreign languages come out as ?????

I've Googled until my fingers are numb testing various suggestions concerning the doctype and utf-8 and many, many other things but I cannot get the languages to display correctly in any screen.

I was wondering if anyone out there has accomplished the above (multiple languages on a page) and can paste a simple HTML example (<html> down to </html>) that I can use to finally get passed this problem.

Thanks, fingers crossed,

Mick

innerspace Silver Member

innerspace

Posted
Posted

Utf8 will do it, but need to make sure it is utf8 every step of the route from final html output (html charset attribute) to the database tables and every transport/processing step in between.

Im linux not ms so cant give specifics but fairly sure these steps will lead you towards the solution.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.






ASEANNOW

ASEANNOW (formerly Thai Visa) Thailand's oldest and most popular forum for expats and foreigners.

Sign up today and have your say

MORE INFO

POPULAR AREAS

CONTACT US

219/59 Asoke Towers, 15th Floor, Soi Sukhumvit 21, Watthana, Bangkok 10110
(+66) 99 196 1100
[email protected]

×
×
  • Create New...