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 |
|
panosrob
Starting Member
2 Posts |
 Posted - 2012-09-23 : 16:52:51
|
| I have a greek database in sql server 2008 and i'm using php to retrievethe data to a website.In the connection parameters i added CharacterSet=utf-8 and in the html header charset=utf-8.The datatype of every string field is nvarchar.When i retrieve the data from the sql server it shows properly on the website,but if i retrieve the column names with sqlsrv_field_metadata it shows the column names with questionmarks.If retrieve the column names from the information_schema.columns view it shows properly.What can i do to get column names from sqlsrv_field_metadata?Is there a way to find out if the column names are varchar or nvarchar? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-23 : 20:09:46
|
| does collation supports greek characters?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
panosrob
Starting Member
2 Posts |
Posted - 2012-09-25 : 11:36:08
|
| the database collation is greek_ci_as. |
|
|
|
|
|
|
database column names not showing properly