Welcome to Sign in | Help
in Search
Home Blogs External Feeds Forums Photos Downloads About Us
» Romanian Section » Intrebari » T-SQL » Re: Import date din fisier .txt UNICODE - Probleme la INSERT

Import date din fisier .txt UNICODE - Probleme la INSERT

Last post 04-20-2008, 6:10 PM by B_gd_n[ ]Sahlean. 2 replies.
Sort Posts: Previous Next

  •  04-20-2008, 2:53 AM 4692

    Import date din fisier .txt UNICODE - Probleme la INSERT

    Reply Quote

    Salut,

    Scenariu

    SQL Server 2005, camp nvarchar, insert date prin import din fisier .txt Fisierul .txt a fost salvat ca Unicode.

    şţâăî in baga in baza de date ca ÿþ_câî3 (adica sh, tz, etc)

    Scriptul de INSERT nu are probleme, campul este definit corect ... nu stiu ce sa-i fac.

    Multumesc

  •  04-20-2008, 6:03 PM 4693 in reply to 4692

    Re: Import date din fisier .txt UNICODE - Probleme la INSERT

    Reply Quote
    /*c:\produs.txt
    1,pix
    2,carneţel
    3,corcoduşe
    4,ursuleţi
    5,imprimantă
    */

    CREATE TABLE tblProdus
    (
      Cod INT PRIMARY KEY,
      Denumire NVARCHAR(25) NOT NULL
    )
    GO

    BULK INSERT tblProdus
    FROM 'c:\produs.txt'
    WITH
    (
    FIELDTERMINATOR = ',',
    ROWTERMINATOR = '\n',
    DATAFILETYPE = 'widechar'
    )
    GO
    /*
    (5 row(s) affected)
    */

    SELECT *
    FROM tblProdus
    GO

  •  04-20-2008, 6:10 PM 4694 in reply to 4693

    Re: Import date din fisier .txt UNICODE - Probleme la INSERT

    Reply Quote
    Rezultat:
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems