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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-31 : 21:57:21
|
| Christopher writes "I am currently designing a Real Estate search website, and have recently run into a problem with SQL Servers nvarchar field. Due to the possibility if requiring additional languages on the site in the future, I have decided to use the nvarchar data type for many of the descriptive fields of the property, so I can preserve the possible use of Unicode characters later in the development. However, when retrieving information with PHP from these fields, the data-length is being limited to 256 characters, a situation that has truncated SOME of my descriptive fields.In my research, I have found that SQL Server's DBLIB Library that all scripting languages interface to the database with limits nvarchar and varchar to 256 characters. My current solution is I am converting these fields to ntext with the SQL statement, but this requires calling each property individually, rather than using "SELECT * FROM tableName WHERE etc." (yes, I do currently make use of all the columns in each row). Is there any way around this that will not make my SQL statement over 7 lines long?SQL Server 2000Windows Server 2003IIS 6.0Christopher" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-10-31 : 21:59:44
|
| Was it a big pole?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Server nvarchar DBLIB