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 - 2005-12-05 : 18:35:15
|
| importing a visual fox pro file -dbf contians herbewhow can i do this?at the moment i recive an error message :[url]http://bb.1asphost.com/pelegk2/error-dbf.GIF[/url]and when i open the file in fo pro i see only strange characters and not hebrew - why?thnaks i nadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-05 : 21:16:24
|
| 1. You will need to import the Hebrew into an NVARCHAR column. 2. The application pulling the data from SQL Server will need to support displaying Hebrew.3. Your particular error...you have to import a valid date. In debug mode, find out the exact value that's being passed in during that error and make sure it's a valid date. You can also search all the values of the column and validate them all with ISDATE. You can look up the details of this function in Books Online.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-12-05 : 22:24:17
|
Derrick is right on his points, but the error in the gif image indicates a TIMESTAMP datatype error. Timestamp isn't a date or time stamp at all.From BOL: quote:
timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
|
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-12-07 : 16:27:14
|
| derrickleggett : how execlly do i do what you have written?how do i do it n tesql serverIsrael -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 - 2005-12-07 : 16:42:43
|
| ok i have succed importing the db but the hebrew was import in reverse 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 -:) |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2005-12-08 : 04:10:44
|
quote:
Originally posted by pelegk2
the hebrew was import in reverse what can i do?
Are you sure about that? It will look like the characters are in reverse order in Query Analyzer and Enterprise Manager because these applications always render text LtR, even if the Unicode characters are RtL. If you look at the same string in a modern web browser, it will get rendered RtL. For example, if you have a web page like this, the Hebrew characters will get rendered in proper Hebrew reading order (RtL) although the surrounding text will appear in proper latin reading order (LtR):<html><head><title>Test</title><body><p>Hebrew: start #x05D0;#x05D1;#x05D2;#x05D3; end</p></body></html> |
|
|
|
|
|
|
rting a visual fox pro file -dbf contians herbrew