villagegreen Posted September 12, 2007 Share Posted September 12, 2007 I'm trying to use an html form to upload foreign language translations of English terms into a MySQL database. Since many different languages will be entered on the page, I have read that I should set the charset on my uploading page as follows: <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> This has worked great for many different languages, including: Arabic, Spanish, Mandarin, etc. Basically, I have all the translations in a Word doc and simply copy and paste them one at a time into a text box in the html form and then hit a submit button to upload them to a field in the database table of type 'blob'. I have been able to pull these translations from the database and display on the web without any problem, except I can't get the Hindi terms to work. The font I'm copying from the Word doc is 'Kruti Dev 010'. When I copy the translation from the Word doc and paste it into the text box in my form, it turns to gibberish, i.e. 'iw.kZ U;wVªksfQy la[;k'. How is it that every other language works except for Hindi? The weird thing is that I have found Hindi text displayed on various websites which I am able to copy and paste successfully into my text box. I just can't copt and paste successfully from my Word doc. I've been searching the web for hours and am at a loss. Any help would be greatly appreciated! Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted September 12, 2007 Share Posted September 12, 2007 When you solve this - let me know - I have a multilingual site in progress and I am scared to death at how I am going to display and process chinese, japanese, hebrew and those ####### french letters with the dash on the top etc etc etc... Quote Link to comment Share on other sites More sharing options...
jordanwb Posted September 14, 2007 Share Posted September 14, 2007 Well for the french letters I think there are escape codes for them: http://w3schools.com/tags/ref_entities.asp Quote Link to comment Share on other sites More sharing options...
Gath Posted September 15, 2007 Share Posted September 15, 2007 When you solve this - let me know - I have a multilingual site in progress and I am scared to death at how I am going to display and process chinese, japanese, hebrew and those ####### french letters with the dash on the top etc etc etc... Those are not french. Unless by dash you mean "á", and still, saying they are french, isnt accurate. Quote Link to comment Share on other sites More sharing options...
ToonMariner Posted September 15, 2007 Share Posted September 15, 2007 I was being flippant - clearly lost on some though. All teh same I am still interested in processing of non-latin charsets so if you do have any joy please post some links up - many thanks... Quote Link to comment Share on other sites More sharing options...
TheFilmGod Posted September 17, 2007 Share Posted September 17, 2007 Isn't there some other charset setting out there? And when added to mysql don't you need to change the collation? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.