[Eventually useful]The lllllllllllllllll issue

So well just wrote sth little regarding to the "capital i's, small L's-problem".

Either you change the font or you can search for the Charname/Job Alias through the following lil query..

PHP Code:

---

USE SRO_VT_SHARD /*Either use Alias or Charname*/

/*Alias*/Declare @Alias varchar(15) SET @Alias = 'IIIll'
/*Charname*/Declare @Charname varchar(15) SET @CharName = ''

if    ((@Alias COLLATE Latin1_General_CS_AS like '%l%' OR @Alias COLLATE Latin1_General_CS_AS like '%I%') 
    OR @Charname COLLATE Latin1_General_CS_AS like '%l%' OR @Charname COLLATE Latin1_General_CS_AS like '%I%' ) -- COLLATE Latin1_General_CS_AS = Case Sensitive
        begin
            if (LEN(@Alias) > LEN(@Charname))
                begin
                    Declare @LengthAlias varchar(15) SET @LengthAlias = LEN(@Alias)
                    SELECT CharName16, NickName16, CurLevel, Strength, Intellect, HP, MP, LatestRegion FROM _Char WHERE (NickName16 COLLATE Latin1_General_CS_AS like '%I%' OR NickName16 COLLATE Latin1_General_CS_AS like '%l%') AND LEN(NickName16) = @LengthAlias 
                end
            else begin
                Declare @LengthCharname varchar(15) SET @LengthCharname = LEN(@Charname)
                SELECT CharName16, NickName16, CurLevel, Strength, Intellect, HP, MP, LatestRegion FROM _Char WHERE (CharName16 COLLATE Latin1_General_CS_AS like '%I%' OR CharName16 COLLATE Latin1_General_CS_AS like '%l%') AND LEN(CharName16) = @LengthCharname 
            end
        end
else
        begin
            if (LEN(@Alias) > LEN(@Charname))
                begin
                    SELECT CharName16 FROM _Char WHERE (NickName16 = @Alias)
                end
            else 
                begin
                    SELECT NickName16 FROM _Char WHERE (CharName16 = @Charname)
                end
            end 


---

If the Nick which you typed in contains an I or a l it throws every charname out with those letters + only those with the length of the typed in Nick.
(Charnick, Alias, Level, HP, MP, STR, INT, Latest Region as well)