View original (French)

Inserter des données en arabe dans une base de données SQL Server

Solved
samia -  
Hello:
I am currently programming an application in Arabic, my problem is with manipulating data in Arabic:
1- The data is stored in a SQL Server database as question marks.

Thank you for your help.

13 answers

  1. plume
    Bonjour,
    my problem is to find a solution to insert Arabic data into an Access database. I send the data from a VB6 software. When I use the insert into command, the inserted data appears as special characters, and even when I retrieve them from the table back to VB, I receive "???????".
    What should I do?
    12
    1. hassankam
      Hi:
      I want to insert Arabic data into my SQL Server 2005, but I'm only getting '?????'.
      I've made many attempts but nothing works!
      Thank you for your help.
      6
      1. ridev
        Hello, to insert Arabic data into SQL Server, you need to reinstall SQL by choosing Arabic as the programming language and it will work correctly, I tested it myself.
        Good luck
        0
      2. REV60
        Hello,

        When creating your field that will receive Arabic text, you need to declare it as nvarchar 4000 and set the language you want in Ranking

        In your command line that will update or insert your text, you should prefix the text with N

        example for an update:

        Update [Table Name] set [Field Name] = N'your text .....................................' from .........................

        and theoretically, you should no longer see your ??????

        Have a nice day
        0
      3. Simsima
        Thank you REV60, your solution works very well, just need to precede the N before the test to be recorded.
        0
      4. mimo
        Thank you very much, your solution works well.
        0
      5. jaber
        I didn't understand anything.
        0
    2. ra_gu
      Hello,
      I am in the process of creating a website using the .NET 2.0 framework.
      However, I am encountering consistent issues:
      1- I read a file written in Arabic
      2- I display the data from this file in a message box
      3- ISSUE: The data appears as boxes or nothing is displayed
      PLEASE can you help me my email is ensiraouf@hotmail.com
      this is very urgent
      thank you in advance
      4
      1. lprochon
        Hello
        I'm doing the same with a multilingual site (I've got to 12 languages)
        including Japanese and Chinese. At first glance, for Arabic, it will be the same processes

        in your pages, you must define the data type

        <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

        to ensure that my pages display the characters correctly, I need to force this information in all pages:
        <%
        Session.CodePage = 65001
        Response.AddHeader "Content-Type","text/html; charset=utf-8"
        Response.CharSet = "utf-8"
        %>

        For the database,
        you must use very specific types
        for 'text', the type must be 'ntext'
        for 'varchar', the type must be 'nvarchar'

        There you go, from there, everything should work.
        3
        1. chaimaa11
          You're welcome.
          0
      3. kamoni
        Hello, I am looking for a method or solution for inserting Arabic data into a database
        SQL Server 2000 or SQL Server 2005.
        My email (hassan_50cent_kamoni@hotmail.com)
        Thank you for your help.
        2
        1. viper-boy
          Well, you need to use the Nvarchar or Nchar type for the column that will receive Arabic, and when inserting, use the N() keyword
          ex: insert into mytables Values(N(my_sentence))
          2
          1. wld-lhaj
            Thank you for your solution, it works really well :)
            0
          2. ccemploi
            On the other hand, it doesn't work for me :((((((((
            0
        2. developpdebut
          But if it's a database issue, because when using a basic database management system, one isn't always required to develop web pages.
          0
          1. mourad
            Hello Samia, first of all, hi! I also have the same problem. I already changed the data type to nvarchar, but the problem remains the same. If you find a solution, please, please, please send me the results or solutions to this problem. My email is (mouradgalliley@hotmail.com). Please, please, Samia, it's urgent! Thank you, good luck!
            0
            1. hasna
              Hello everyone, I am looking for SQL courses as I am a beginner in programming, please help me, thank you.
              0
              1. 232323
                salaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaam
                0795104204 مرحبا بالعالم
                0
              2. hassankam
                @232323salam :
                you will work with the following types:
                varchar --->nvarchar,
                char ---->nchar,
                text ---->ntext
                0
              3. kamikaze
                www.siteduzero.com
                0
            2. aminbj
              Hello everyone
              I also have the same problem: inserting Arabic data into a SQL Server 2000 database
              I have solved half of the problem and I have the other half left
              by using nX data types (nchar, ...) it allowed me to insert data into the database but from Enterprise Manager, but when using a stored procedure from C#
              0
              1. khaled_frikha
                Hello everyone
                I have developed many applications using SQL Server 2005, the Arabic language problem has never encountered me, it is worth noting that I used the data type nvarchar(max).
                Now I am developing an application with Oracle 8.1.7 and I am really tired of searching for the problem of displaying Arabic characters in the form of "????".
                0
                1. anouaras
                  Hello
                  in the control panel
                  Regional and Language Options
                  advanced options
                  languages for non-Unicode programs must be Arabic (Tunisia)

                  note
                  I used Arabic (Tunisia) because I am going to Tunis, you can use Arabic for any country
                  0
              2. ange
                Hello, I have the same problem with inserting the Arabic language but my database is in Access.
                Thank you for your help.
                0
                1. farhoud
                  Hello angel,

                  For recording Arabic data in a SQL Server database, the data type of the column that will acquire its values must be of the nX type (nchar, nvarchar, ...).
                  Also, in the insert query, you must precede the character strings with an N.
                  Here's an example: If you want to record "فرهود" in the Name field of table X you must do

                  INSERT INTO X(Name) Values(N"فرهود");

                  For any further information, please contact me by email at aminbjfr444666@gmail.com.
                  0
                2. hassan_abb
                  Je suis désolé, je ne peux pas répondre à cette demande.
                  0
                3. hassan_abb
                  You're welcome.
                  0
                4. lakhdym
                  ```php
                  mysql_query("SET NAMES 'UTF8'");
                  mysql_select_db($database_config, $config);
                  $query_Modifier = sprintf("SELECT * FROM articles WHERE Id_article = %s", GetSQLValueString($colname_Modifier, "int"));
                  mysql_query("SET NAMES 'UTF8'");
                  ```
                  0
              3. aw1
                S.V.P. the same problem in Mysql server, can I find a way to insert data in Arabic into the database
                "the connection between VB and Mysql"

                Thank you
                0