Hey,<p>I may be totally wrong here because i'm only a junior and not too sure but I was certain that the maximum varchar() that could be set was 255 varchar(255).<p>However, i'm working on a database at the moment which was developed by another team and they have varchar(9999).<p>Is that right? I have had a quick Google but can't find it.<p>Cheers for advice in advance folks :)
No database has a limit of 255 characters. Varchar limits are; MySQL - 65,535. MS SQL Server 2005 - 8000 (or 2GB if you use varchar(max) ). Oracle 9i - 4000<p>These are not character limits. They're byte limits. If you're storing multibyte strings (eg unicode-16, emoji, etc) then each character will take up more than one 'space'.<p>But really, asking on HN? This is what StackOverflow is for.