As a MySQL adept, it’s quite a change to query an MS SQL Server. Today I wanted to select all items from a table where a field wasn’t an empty string (really empty string as in ”, not as in being NULL). Merely a SELECT * FROM myTable WHERE myField != ” right? Wrong!
Author Archives: Bramus!
Map of online communities and related points of interest
My DOTD: MS SQL vs. PHP: 4096 is the (default) limit
Small tip: when getting data from a MS SQL Database through PHP you’ll notice that your data gets chopped. First thought that the datatypes of the fields weren’t sufficient enough to hold the data, but the text datatype can hold up to 2ˆ31 – 1 characters and the data was stored correctly in the database …
Continue reading “My DOTD: MS SQL vs. PHP: 4096 is the (default) limit”