www.hkvforums.com

Hello ,
I have an ASP.Net Maker project that Add/Updates data from MS Sql Server 2008 . The text contains some Turkish characters . The Advanced search doesn't retrieve any records if the field contains the turkish character "ı". It works for other turkish characters.
For e.g. the search for "SlimCap kapaklı" returns zero records even though there are records in the table that contains this text.
On the other hand the search for Süt returns the correct number records.

So the issue seems to be only with the character "ı" character.

Any ideas how can fix this issue ?

Thanks

What is the data type of the field? Is it nvarchar? If you use varchar only, it may not work. Post your table schema (CREATE TABLE statement).

Hi,
It is nvarchar.
As I mentioned , other Turkish characters get searched without any issues. Its only the "i" that has the issue
Regards
Yasir

Below is the table schema. I am searching on the ProductName column.

CREATE TABLE [TRProduction].[ProductPlan](
[ProductPlan_Id] [bigint] IDENTITY(1,1) NOT NULL,
[ProductName] nvarchar NULL,
[LastOrderDate] [date] NULL,
[DeliveryDate] [date] NULL,
[NextDeliveryDate] [date] NULL,
CONSTRAINT [PKProductPEE81172E534D60F1] PRIMARY KEY CLUSTERED
(
[ProductPlan_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
REATE TABLE [TRProduction].[ProductPlan](
[ProductPlan_Id] [bigint] IDENTITY(1,1) NOT NULL,
[ProductName] nvarchar NULL,
[LastOrderDate] [date] NULL,
[DeliveryDate] [date] NULL,
[NextDeliveryDate] [date] NULL,
CONSTRAINT [PKProductPEE81172E534D60F1] PRIMARY KEY CLUSTERED
(
[ProductPlan_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Export and post INSERT statements with problem data from the table so it can be tested.

Hi,
Below are the Insert statements. The text (kapaksız, ReCap3 veya SlimCap kapaklı) can't be searched since it contains the ı character.

SET IDENTITY_INSERT [TRProduction].[ProductPlan] ON
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1284, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xA53B0B00 AS Date), CAST(0xAC3B0B00 AS Date), CAST(0xB33B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1285, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xAC3B0B00 AS Date), CAST(0xB33B0B00 AS Date), CAST(0xBA3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1286, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xB33B0B00 AS Date), CAST(0xBA3B0B00 AS Date), CAST(0xC13B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1287, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xBA3B0B00 AS Date), CAST(0xC13B0B00 AS Date), CAST(0xC83B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1288, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xC13B0B00 AS Date), CAST(0xC83B0B00 AS Date), CAST(0xCF3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1289, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xC83B0B00 AS Date), CAST(0xCF3B0B00 AS Date), CAST(0xD63B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1290, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xCF3B0B00 AS Date), CAST(0xD63B0B00 AS Date), CAST(0xDD3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1291, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xD63B0B00 AS Date), CAST(0xDD3B0B00 AS Date), CAST(0xE43B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1292, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xDD3B0B00 AS Date), CAST(0xE43B0B00 AS Date), CAST(0xEB3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1293, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xE43B0B00 AS Date), CAST(0xEB3B0B00 AS Date), CAST(0xF23B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1294, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xEB3B0B00 AS Date), CAST(0xF23B0B00 AS Date), CAST(0xF93B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1295, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xF23B0B00 AS Date), CAST(0xF93B0B00 AS Date), CAST(0x003C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1296, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0xF93B0B00 AS Date), CAST(0x003C0B00 AS Date), CAST(0x073C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1297, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x003C0B00 AS Date), CAST(0x073C0B00 AS Date), CAST(0x0E3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1298, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x073C0B00 AS Date), CAST(0x0E3C0B00 AS Date), CAST(0x153C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1299, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x0E3C0B00 AS Date), CAST(0x153C0B00 AS Date), CAST(0x1C3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1300, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x153C0B00 AS Date), CAST(0x1C3C0B00 AS Date), CAST(0x233C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1301, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x1C3C0B00 AS Date), CAST(0x233C0B00 AS Date), CAST(0x2A3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1302, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x233C0B00 AS Date), CAST(0x2A3C0B00 AS Date), CAST(0x313C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1303, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x2A3C0B00 AS Date), CAST(0x313C0B00 AS Date), CAST(0x383C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1304, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x313C0B00 AS Date), CAST(0x383C0B00 AS Date), CAST(0x3F3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1305, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x383C0B00 AS Date), CAST(0x3F3C0B00 AS Date), CAST(0x463C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1306, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Süt', CAST(0x3F3C0B00 AS Date), CAST(0x463C0B00 AS Date), CAST(0x4D3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1323, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xAC3B0B00 AS Date), CAST(0xB33B0B00 AS Date), CAST(0xBA3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1324, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xB33B0B00 AS Date), CAST(0xBA3B0B00 AS Date), CAST(0xC13B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1325, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xBA3B0B00 AS Date), CAST(0xC13B0B00 AS Date), CAST(0xC83B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1326, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xC13B0B00 AS Date), CAST(0xC83B0B00 AS Date), CAST(0xCF3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1327, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xC83B0B00 AS Date), CAST(0xCF3B0B00 AS Date), CAST(0xD63B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1328, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xCC3B0B00 AS Date), CAST(0xD43B0B00 AS Date), CAST(0xD83B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1329, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xD03B0B00 AS Date), CAST(0xD83B0B00 AS Date), CAST(0xE43B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1330, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xD73B0B00 AS Date), CAST(0xE43B0B00 AS Date), CAST(0xEB3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1331, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xE43B0B00 AS Date), CAST(0xEB3B0B00 AS Date), CAST(0xF23B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1332, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xEB3B0B00 AS Date), CAST(0xF23B0B00 AS Date), CAST(0xF93B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1333, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xF23B0B00 AS Date), CAST(0xF93B0B00 AS Date), CAST(0x003C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1334, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0xF93B0B00 AS Date), CAST(0x003C0B00 AS Date), CAST(0x073C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1335, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x003C0B00 AS Date), CAST(0x073C0B00 AS Date), CAST(0x0E3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1336, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x073C0B00 AS Date), CAST(0x0E3C0B00 AS Date), CAST(0x153C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1337, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x0E3C0B00 AS Date), CAST(0x153C0B00 AS Date), CAST(0x1C3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1338, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x153C0B00 AS Date), CAST(0x1C3C0B00 AS Date), CAST(0x233C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1339, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x1C3C0B00 AS Date), CAST(0x233C0B00 AS Date), CAST(0x2A3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1340, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x233C0B00 AS Date), CAST(0x2A3C0B00 AS Date), CAST(0x313C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1341, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x2A3C0B00 AS Date), CAST(0x313C0B00 AS Date), CAST(0x383C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1342, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x313C0B00 AS Date), CAST(0x383C0B00 AS Date), CAST(0x3F3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1343, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x383C0B00 AS Date), CAST(0x3F3C0B00 AS Date), CAST(0x463C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1344, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x3F3C0B00 AS Date), CAST(0x463C0B00 AS Date), CAST(0x4D3C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1345, N'Tetra Brik Aseptic 1000 Slim (kapaksız, ReCap3 veya SlimCap kapaklı) Meyve Suyu', CAST(0x463C0B00 AS Date), CAST(0x4D3C0B00 AS Date), CAST(0x543C0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1359, N'Tetra Brik Aseptic 1000 Slim Helicap', CAST(0x983B0B00 AS Date), CAST(0x9F3B0B00 AS Date), CAST(0xA63B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1360, N'Tetra Brik Aseptic 1000 Slim Helicap', CAST(0x9F3B0B00 AS Date), CAST(0xA63B0B00 AS Date), CAST(0xAD3B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1361, N'Tetra Brik Aseptic 1000 Slim Helicap', CAST(0xA63B0B00 AS Date), CAST(0xAD3B0B00 AS Date), CAST(0xB43B0B00 AS Date))
INSERT [TRProduction].[ProductPlan] ([ProductPlan_Id], [ProductName], [LastOrderDate], [DeliveryDate], [NextDeliveryDate]) VALUES (1362, N'Tetra Brik Aseptic 1000 Slim Helicap', CAST(0xAD3B0B00 AS Date), CAST(0xB43B0B00 AS Date), CAST(0xBB3B0B00 AS Date))

Try to add the word "kapaklı" and search without issue. What version you are using?

I am using ASP.Net Maker v11.0.2

v11 is too old to be discussed here. Please download the latest version to try.