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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2014-08-04 : 10:34:44
|
| Hi.Everything works fine on anything else but when i get an excel column that (greek characters) has , for example "greekgreekgrekk." (greek chars as i've said"), then the result of the column name in sql will be "greekgreekgrekk#"Why?Thanks.P.S. I am doing the codepage in 1253 greek on bulk. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-04 : 12:25:06
|
| By "in sql", do you mean Management Studio? I don't think SSMS can properly read the characters, though your application that supports it can.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2014-08-04 : 17:55:51
|
| Hi, yes i see a "#" instead of a dot. I was told that maybe this has to do that the dot is reserved but i don't see a problem when i do a select [column.] from table1 .So even if the SSMS shows "#" the column name is with a dot? Meaning SSMS shows column1# but in reality is column1. ? That is very confusing if true.Thanks.P.S. The application is excel. The bulk reads row1 of excel that has the column values and 2 or 3 of them has a dot for a sortcut, like Nubmer of invoc. |
|
|
|
|
|
|
sql insert hash insted of dot in column name on bu