Open shengguo opened 3 weeks ago
实测当使用like('字段', '%测试%')和supabase.js一样可以正常转码, 请求为 https://coumbga5g6hc2l9v8nk0.baseapi.memfiredb.com/rest/v1/workouts?select=*&workoutName=like.%25%E6%B5%8B%E8%AF%95%25 但使用like('字段', '%12%'), 这里是数字, 就不会进行转码了, 导致无法查询到数据.
举例子: supabase-wechat-stable-v2的请求为 https://coumbga5g6hc2l9v8nk0.baseapi.memfiredb.com/rest/v1/workouts?select=*&workoutName=like.%12% supabase的请求为 https://coumbga5g6hc2l9v8nk0.baseapi.memfiredb.com/rest/v1/workouts?select=*&workoutName=like.%2512%25
目前的做法: 修改代码为 const likeStr = '%' + wLike + '%' const { data: workouts, error } = await supabase .from('workouts') .select('*') .like('workoutName', encodeURIComponent(likeStr)) 我自己用encodeURIComponent做了转码才能取到数据, 希望官方可以修复这个问题
实测当使用like('字段', '%测试%')和supabase.js一样可以正常转码, 请求为 https://coumbga5g6hc2l9v8nk0.baseapi.memfiredb.com/rest/v1/workouts?select=*&workoutName=like.%25%E6%B5%8B%E8%AF%95%25 但使用like('字段', '%12%'), 这里是数字, 就不会进行转码了, 导致无法查询到数据.
举例子: supabase-wechat-stable-v2的请求为 https://coumbga5g6hc2l9v8nk0.baseapi.memfiredb.com/rest/v1/workouts?select=*&workoutName=like.%12% supabase的请求为 https://coumbga5g6hc2l9v8nk0.baseapi.memfiredb.com/rest/v1/workouts?select=*&workoutName=like.%2512%25
目前的做法: 修改代码为 const likeStr = '%' + wLike + '%' const { data: workouts, error } = await supabase .from('workouts') .select('*') .like('workoutName', encodeURIComponent(likeStr)) 我自己用encodeURIComponent做了转码才能取到数据, 希望官方可以修复这个问题