Question: I want to store Kannada in sql server 2005. I tried to insert via query and baraha direct. that stored as ?????

. Can any one please tell me how i can store Kannada in sql server 2005.
i went through the following link they are telling Kannada is not supporting by default. Is it true?.

<http://msdn.microsoft.com/en-us/library/ms143508%28v=sql.105%29.aspx>

or am i need to set any collation?

Answer: 
`LOAD DATA INFILE` is the fastest.

hello, so you are dumping table by your own program. if loading speed is important. please consider belows:

* ensure that multiple `INSERT INTO .. VALUES (...), (...)`
* Disable INDEX before loading, enable after loading. This is faster.
* `LOAD DATA INFILE` is super faster than multiple INSERT but, has trade-off. maintance and handling escaping.
* BTW, I thing `mysqldump` is better than others.

how long takes to load 45,000 rows?
`INSERT` is faster, because you are skip parsing of csv.

If your table at `MyISAM`, you can copy files: `*.frm`, `*.myi`, `*.myd` and this migration will be faster.