Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-04-27 : 05:05:53
|
| i have imported a text file which contians hebrew text in iti got 6 columns.the DataType of the columns is : NCAHR with the size i told it to each delimiter from the text file.in the colmuns that the text dosnet contiani execlly the number of chars like the DataType size, the text is like " align : center" i tried to make LTRIM and RTIRM but no luck!after that i did reverse to fix the RTL problem of hebrw and then the text is START from a starting position (so i thought so)but when i debuged it with a while loop i found out hat at first i get the space (chr(32)) values and only in the end the values of the text itself!!!!which means its aligned in the cell to the opposite side!!!the most bigger problem is that i can read of the spaces!!!!!!LTRIM RTRIM REPLACE nothing didnt wwork!i check and the spaces are chr(32)!!!what can i do?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2006-04-27 : 08:05:57
|
| solved itcnverted the nchar to nvarchar :)Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
 |
|
|
|
|
|
imported files and SPACE problem