SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 sql insert hash insted of dot in column name on bu
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sapator
Constraint Violating Yak Guru

Greece
383 Posts

Posted - 08/04/2014 :  10:34:44  Show Profile  Reply with Quote
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

USA
37133 Posts

Posted - 08/04/2014 :  12:25:06  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sapator
Constraint Violating Yak Guru

Greece
383 Posts

Posted - 08/04/2014 :  17:55:51  Show Profile  Reply with Quote
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.

Edited by - sapator on 08/04/2014 17:58:14
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000