mysql - Laravel 查询 - 执行查询时 Laravel 似乎在每个字母之间添加 ?/空格

Question

从 country_code 中选择 code，其中 country = '?U?n?i?t?e?d? ?K?i?n?g?d?o?m' 按国家/地区 asc 限制 1

排序

public function location_test(){

   $locations = DB::table('accesses')
                ->select('country' ,DB::raw('count(*) as count'))
                ->join('ip2c_cache', 'accesses.ip', '=', 'ip2c_cache.ip')
                ->where('showcase_id', 5613)->groupby('country')
                ->get();

    $mapData = "";
    $locationData = array();

   foreach ($locations as $location) {

        $code = DB::table('country_code')
                    ->select('code')->where('country', $location->country)
                    ->orderBy('country')
                    ->first();

         $mapData = $mapData . '"' . $code->id . '":"' . $location->count . '",';
     }
  return $mapData;
}

Answer 1

当我更改数据库的排序规则时问题已解决