How to insert Khmer text into SQL Server 2008
Phú Phan Trần
I'm using Microsoft SQL Server 2008 SP2 for a database in which I need to write either Khmer Unicode or English letters.
And I code website by Codeigniter.
My database is using Colattion: SQL_Latin1_General_CP1_CI_AS.
Type Column Name : nvarchar(250).
Query via Codeigniter php:
insert into Genres (Name) values(N'ការបង្ហាញ')
But in my database when I right click on table, select edit top 200 . The result for Name in table look like this:
ការបង្ហាញ
I want my result at Name Column is : ការបង្ហាញ
How to insert Khmer Text still not change in database?
Thanks.
Jeroen Flamman
It works for me if I change the collation of the table: 
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
관련 기사
Related 관련 기사
- 1
Insert 문 검사가 NULL SQL Server 2008 임
- 2
SQL Server 2008 : how to remove char(0)
- 3
How to insert & update the same inserted multiple record in SQL Server 2008 R2 using multithread in windows service(C#)?
- 4
삽입시 SQL Server 2008 "IDENTITY_INSERT is ON"오류
- 5
IDENTITY_INSERT ON이 작동하지 않음-SQL Server 2008 R2
- 6
How to get sum of time field in SQL server 2008
- 7
how can we change the date format of SQL Server(2008) Database?
- 8
how to pivot on number of rows in SQL Server 2008+
- 9
How to display all the days of a month in SQL Server 2008?
- 10
IBM WORKLIGHT SQL Server 2008
- 11
SQL Server 2008의 ORDER BY
- 12
SQL Server 2008 connection error
- 13
SQL SERVER 2008 Select 문
- 14
SQL Server 2008-With 절
- 15
how to insert sql dump into remote mysql server using PuTTY?
- 16
how to insert sql dump into remote mysql server using PuTTY?
- 17
Alter table query plan for sql server 2008
- 18
Creating clients of SQL Server 2008 in same network
- 19
SQL Server 2008-피벗
- 20
SQL Server 2008에서 선택
- 21
누적 SUM SQL Server 2008
- 22
Roll Back Sql Server 2008 query
- 23
Automatic row deletion in SQL Server 2008
- 24
SQL Server 2008 dbms 및 Visual Studio
- 25
Access에서 SQL Server 2008로
- 26
SQL Server 2008 patindex 재귀
- 27
how to split a xml format data into row column format in sql server 2008 using stored procedure
- 28
How to check if SQL Server 2008 R2 database exists using power shell
- 29
SQL Server 2008 two tables with common dates field how to select by datewise from both tables
몇 마디 만하겠습니다