bkkmick Posted May 2, 2015 Share Posted May 2, 2015 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 Link to comment Share on other sites More sharing options...
innerspace Posted May 2, 2015 Share Posted May 2, 2015 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. Link to comment Share on other sites More sharing options...
KittenKong Posted May 2, 2015 Share Posted May 2, 2015 Crikey. You are reinventing the wheel. Why not just use Wordpress and a language plug-in? 1 Link to comment Share on other sites More sharing options...
RichCor Posted May 2, 2015 Share Posted May 2, 2015 ^^^ ...or a CMS that already supports multiple languages. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now