I have a greek database in sql server 2008 and i'm using php to retrieve the 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?
database column names not showing properly
Posted - 09/23/2012 : 16:52:51
