how can i insert multi language data to database in PHP sqlsrv_connect

Question

i need insert multi language title of files in database.

Almost like:

my code:

$databaseName = "databasename"; 
$connectionInfo = array( "UID"=>$uid, "PWD"=>$pwd, "Database"=>$databaseName , "CharacterSet" => "UTF-8"); 

$title = "مشخصات فایل " .  " Основы теории литературы";

    $conn = sqlsrv_connect( $serverName, $connectionInfo);
    $tsql = "INSERT INTO  dbo.Product(title) VALUES ('".$title."')";
    $stmt = sqlsrv_query( $conn, $tsql );

store in database :

Nishant Nair · Accepted Answer · 2017-03-21T09:54:02.967

1

Storing your data in utf8_unicode_ci column would help you to store the data in multi language.

Assuming you are using mysql

 ALTER TABLE t MODIFY LTXT CHAR(49) CHARACTER SET utf8;

While inserting use N

   $tsql = "INSERT INTO  dbo.Product(title) VALUES (N'".$title."')";

edited Mar 21 '17 at 09:54

answered Mar 21 '17 at 09:20

Nishant Nair

1,999
1
13
18

`ALTER TABLE dbo.MyTable ALTER COLUMN LTXT nvarchar(100) COLLATE Latin1_General_CI_AS NOT NULL` – Nishant Nair Mar 21 '17 at 09:33
Command(s) completed successfully. But after insert not changed... https://i.stack.imgur.com/8zSYh.png – Admin File3 Mar 21 '17 at 09:42
Tanks a lot. solve the problem. Can you explain more about this? – Admin File3 Mar 21 '17 at 10:06
you can have a look at [ http://stackoverflow.com/questions/392916/do-i-have-use-the-prefix-n-in-the-insert-into-statement-for-unicode ] – Nishant Nair Mar 21 '17 at 10:13

how can i insert multi language data to database in PHP sqlsrv_connect

1 Answers1