I have raw file with entry in Thai language " Yamato-Esulon (Thailand) Co.,Ltd (โรง 1)' but when i put that on SQL table it changes to 'Yamato-Esulon (Thailand) Co.,Ltd (Ó╣éÓ©úÓ©ç 1)' . I'm using datatype nvarchar(MAX). Has someone come across this before and how can this be prevented?
Foreign language not read correct in SQL
204 Views Asked by Anil Thomas At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in NVARCHAR
- Read huge nvarchar(max) as UTF-16 stream without saturate memory
- How can I use SQL to find results with a dynamic integer field?
- Using nvarchar(max) in Azure stored procedure
- Why do commas take up two bytes?
- SSIS data conversion loses extended ASCII
- If I call Left([col], x) on an NVARCHAR(max) column, is it always safe to save the output in an NVARCHAR(x) column?
- Procedure can't return large string response(~293 characters)
- Updating nvarchar(max) in SQL Server with huge value
- JSON string in MS SQL Server is too large to select without CAST ing to XML
- Changing 8 column type of a big table from nvarchar(max) to varchar(x) with EF code Code-first
- Why does "N" shows up in Excel report from SQL Server data?
- Specific Effects of using nvarbinary vs nvarchar for storing images
- Concat and make a string into a date
- Insert objects into database
- When calling a stored procedure with ADO.NET, how do I tell what parameter types the database actually used?
Related Questions in THAI
- Facing Thai language display issue in AWS Glue ETL with MySQL target. How to fix?
- How to keep punctuation in elasticsearch's thai tokenizer
- Tabula (And PDFPlumber) unable to extract accurately Thai characters from text-based PDF
- Wordpress permanent link thai language issue
- Correct current way on Android to get the current year in Thai digits?
- How to handle combining characters along with the \p{L} pattern for Thai strings?
- Find word boundaries in Southeast Asian Languages (Thai, Khmer, Lao, Myanmar)
- How can I use python to find specific Thai word in multiple csv file and return list of file name that's contain the word
- Merge Thai letters programmatically
- How to set ordering list with Thai character list item type?
- Replace string only if all characters match (Thai)
- php iconv character encoding from Thai ISO-IR-166 to utf-8 doesn't work
- Thai script seems to lose UTF-8 encoding in java for-each loop
- preq_replace automatically adds single quote in Thai language
- Incosistent regex result for Thai characters across different PHP version
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Your problem may be due to the font that you are using. Only certain fonts will work for thai language, so fonts like arial and calibri simply won't work.
For Thai, the fonts that work are: Dialog, DialogInput, Monospaced, Sansserif, Serif, Leewaldee, Leewaldee UI, Leewaldee UI Semilight, Lucida Sans, Lucida Sans Typewriter, Microsoft Sans Serif, and Tahoma
This holds true for almost any other language, so be sure that a certain font works for the language that you are using. You can check which fonts work through a .jar file that I found online relating to an older post.