|
|||||||
New to SitePoint Forums? Register here for free!
|
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
SitePoint Member
Join Date: Jul 2005
Posts: 7
|
Hi,
can anyone please try to filter the following data using rowfilter and see whether it works or not. Note: Have to escape [ and ].So, [ is written as [[] and ] is written as []]. All the data is stored as NVARCHAR not VARCHAR. i'm using visual basic.net V1.1. When the data are stored as unicode, the rowfilter works properly. However, when tehd ata are stored as NVARCHAR, the rowfilter is not working properly. Is is it because the data are stored as NVARCHAR that makes rowfilter doesn't works properly? Three records in the database are: 1# [1222 -2201 ภาษาไทยเพื่อการสื่อสาร] 3# [1212 - 2200 วิทยาศาสตร์พื้นฐาน ] 12# [1122 - 3201 วิถีธรรมวิถีไทย ] Let say i want to get the third record with one of the string below, i can get the desired data. '%12%' '%12#%' '%[[]%' '%[]]%' '%[[]1122%' '%[[]1122 - 3201 วิถีธรรมวิถีไทย []]%' '%#%' '%-%' '%วิถีธรรมว%' However, i can't get the third record if i use one of thestring below. '%# %' (a space after #) '%# [[]%' '%12# [[]%' '%12# %' (a space after #) '%# [[]1122%' '%12# [[]1122 - 3201 วิถีธรรมวิถีไทย []]%' Can you help me? ![]() |
|
|
|
| Bookmarks |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
|
|
|
All times are GMT -7. The time now is 23:36.









Threaded Mode