-
Ask a question and get free supportUnlock new privileges and see hidden discussionsWin prizes and earn reputation
-
Question of the day ~ How often do you braai?
-
Afristay giveaway.Win a 2-night stay for two people at an establishment of your choice with R1,000 in spending money. Enter here.
Sign up with Google
FarligOpptreden
Executive Member
- Joined
- Mar 5, 2007
- Messages
- 5,396
Only noticed the thread here... 
Other Pineapple Smurf
Honorary Master
- Joined
- Jun 21, 2008
- Messages
- 14,593
SELECT * FROM table WHERE advice='help';
guest2013-1
guest
- Joined
- Aug 22, 2003
- Messages
- 19,800
lol, no he really has a problem.
basically a field isn't limited in the input characters he can put in, but it looks like the PHP reading it out is trunking it.
That was/is his problem.
Google won't fix
basically a field isn't limited in the input characters he can put in, but it looks like the PHP reading it out is trunking it.
That was/is his problem.
Google won't fix
Necuno
Court Jester
- Joined
- Sep 27, 2005
- Messages
- 58,567
What I don't get is why people have to PM him to find out the problem
This is a public forum, post the problem and give everyone a chance to contribute, isn't that the whole point? :erm:
I agree, it's a bit like starting a new thread saying "Please PM me to find out what this post is about".
OK from the limited description i can say that i have had something similar. When a string is written to a SQL Server database with a null char in, some API calls will see the null as the termination of the string and only return everything before the null.
One way to pick this up is to do a normal select in SQL mngt studio (it will terminate after null) count the length and compare that to a len(fieldname) select (it wont terminate).
One way to pick this up is to do a normal select in SQL mngt studio (it will terminate after null) count the length and compare that to a len(fieldname) select (it wont terminate).